<?php
ob_start();
session_start();
?>

<html>
<head>
</head>
<body>
<form name="myform" action="ScheduleResult.php" method="POST">
<div align="center">

<?php
include ("connect.php");
$dbname = 'Transportation';
mysql_select_db($dbname);
$page_title = "Abu Dhabi Transportation Website - Schedule Search";
$loginText = "Sign In";
$leftMenu = array
	(
		 "Home" => "index.php",
		"Routes" => "routes.php",
		"Schedule" => "Schedule.php",
		"Stops" => "Stops.php",
		"How To Go There" => "#",
	);
	

$content = "Please select the Bus Number<br/><br/><br/>";

$q = "SELECT DISTINCT BusID,BusName FROM busroutes order by 1";
$result = mysql_query($q);

$content .= 'Bus Number: &nbsp';

$content .= '<select name="mydropdown1">';
while ($row = mysql_fetch_array($result)) 
{
$content .= '<option value='.$row['BusID'].'>'.sprintf("%s : %s", $row['BusID'], $row['BusName']).'</option>';
}
$content .= '</select>';
$content .= '<br/><br/>';

mysql_close($connect);
$content .= '<br/><br/><br/><br/>';

$content .= '<input type = "submit" />';

include("default_layout.php");
?>





</div>
</form>
</body>
</html>